home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 313 < prev    next >
Unknown  |  1998-01-30  |  640 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 52 45 53 |CHILD DE|LETE RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 20 2f 2a 20 45 52 77 |TRICT.  |  /* ERw|
|00000020| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000030| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 20 20 2f 2a 20 |time */.|.    /* |
|00000040| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00000050| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|00000060| 49 4c 44 20 44 45 4c 45 | 54 45 20 52 45 53 54 52 |ILD DELE|TE RESTR|
|00000070| 49 43 54 20 2a 2f 0d 0a | 20 20 20 20 69 66 20 65 |ICT */..|    if e|
|00000080| 78 69 73 74 73 20 28 73 | 65 6c 65 63 74 20 2a 20 |xists (s|elect * |
|00000090| 66 72 6f 6d 20 64 65 6c | 65 74 65 64 2c 25 50 61 |from del|eted,%Pa|
|000000a0| 72 65 6e 74 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |rent..  |    wher|
|000000b0| 65 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 25 25 |e..     |   /* %%|
|000000c0| 4a 6f 69 6e 46 4b 50 4b | 28 64 65 6c 65 74 65 64 |JoinFKPK|(deleted|
|000000d0| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|000000e0| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|000000f0| 20 20 20 25 4a 6f 69 6e | 46 4b 50 4b 28 64 65 6c |   %Join|FKPK(del|
|00000100| 65 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |eted,%Pa|rent," =|
|00000110| 20 22 2c 22 20 61 6e 64 | 22 29 20 61 6e 64 0d 0a | "," and|") and..|
|00000120| 20 20 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |        |not exis|
|00000130| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ts (..  |        |
|00000140| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 25 43 |select *| from %C|
|00000150| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |hild..  |        |
|00000160| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|00000170| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|00000180| 28 25 43 68 69 6c 64 2c | 25 50 61 72 65 6e 74 2c |(%Child,|%Parent,|
|00000190| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|000001a0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a |..      |      %J|
|000001b0| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 25 |oinFKPK(|%Child,%|
|000001c0| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|000001d0| 6e 64 22 29 0d 0a 20 20 | 20 20 20 20 20 20 29 0d |nd")..  |      ).|
|000001e0| 0a 20 20 20 20 29 0d 0a | 20 20 20 20 62 65 67 69 |.    )..|    begi|
|000001f0| 6e 0d 0a 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |n..     | select |
|00000200| 40 65 72 72 6e 6f 20 20 | 3d 20 33 30 30 31 30 2c |@errno  |= 30010,|
|00000210| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 40 |..      |       @|
|00000220| 65 72 72 6d 73 67 20 3d | 20 27 43 61 6e 6e 6f 74 |errmsg =| 'Cannot|
|00000230| 20 44 45 4c 45 54 45 20 | 6c 61 73 74 20 22 25 43 | DELETE |last "%C|
|00000240| 68 69 6c 64 22 20 62 65 | 63 61 75 73 65 20 22 25 |hild" be|cause "%|
|00000250| 50 61 72 65 6e 74 22 20 | 65 78 69 73 74 73 2e 27 |Parent" |exists.'|
|00000260| 0d 0a 20 20 20 20 20 20 | 67 6f 74 6f 20 65 72 72 |..      |goto err|
|00000270| 6f 72 0d 0a 20 20 20 20 | 65 6e 64 0d 0a 00 20 27 |or..    |end... '|
+--------+-------------------------+-------------------------+--------+--------+